﻿USE [TicketAppDB]
GO
/****** Object:  Table [dbo].[Addresses]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Addresses] ON
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (1, N'SMCS-Administrator', N'Administrator-Line2', N'New York', N'Califonia', N'US', N'1111')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (2, N'Agent1', N'Agent1-Line2', N'Agent1-City', N'Agent1-State', N'Agent1-Country', N'2222')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (3, N'Agent1-Branch1', N'Agent1-Branch1-Line2', N'Agent1-Branch1-City', N'Agent1-Branch1-State', N'Agent1-Branch1-Country', N'3333')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (4, N'Event1-Venue', N'Event2-Line2', N'Event2-City', N'Event2-State', N'Event2-Country', N'4444')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (5, N'new-1', N'Organizer1-Line2', N'Organizer1-City', N'Organizer1-State', N'Organizer1-Country', N'5555')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (6, N'Customer1-Address', N'Customer1-Line2', N'Customer1-City', N'Customer1-State', N'Customer1-Country', N'6666')
INSERT [dbo].[Addresses] ([Id], [Line1], [Line2], [City], [State], [Country], [PostalCode]) VALUES (8, N'Line1-2', N'Line2-2', N'City-2', N'State-2', N'Country-2', N'2')
SET IDENTITY_INSERT [dbo].[Addresses] OFF
/****** Object:  Table [dbo].[Events]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Events] ON
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status]) VALUES (2, N'Event1', CAST(0x00009F5C00000000 AS DateTime), CAST(0x00009F5F00000000 AS DateTime), N'IST', N'Event1-Description', 1)
INSERT [dbo].[Events] ([Id], [Name], [StartDateTime], [EndDateTime], [Timezone], [Description], [Status]) VALUES (3, N'Event2', CAST(0x00009F6F00000000 AS DateTime), CAST(0x00009F7800000000 AS DateTime), N'EST', N'Event2-Description', 1)
SET IDENTITY_INSERT [dbo].[Events] OFF
/****** Object:  Table [dbo].[PaymentModes]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[PaymentModes] ON
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (1, N'Cash')
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (2, N'Credit Card')
INSERT [dbo].[PaymentModes] ([Id], [Mode]) VALUES (3, N'Gift Card')
SET IDENTITY_INSERT [dbo].[PaymentModes] OFF
/****** Object:  Table [dbo].[Roles]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Roles] ON
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (1, N'Adminstrator')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (2, N'Organizer')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (3, N'Agent')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (4, N'Customer')
INSERT [dbo].[Roles] ([Id], [Name]) VALUES (9, N'New Role')
SET IDENTITY_INSERT [dbo].[Roles] OFF
/****** Object:  Table [dbo].[TicketTemplates]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[TicketTemplates] ON
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (1, N'HTML formatted Tieckt1 template', N'one')
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (2, N'HTMLformatted Ticket2 template', N'two')
INSERT [dbo].[TicketTemplates] ([Id], [Template], [Name]) VALUES (7, N'three', N'three')
SET IDENTITY_INSERT [dbo].[TicketTemplates] OFF
/****** Object:  Table [dbo].[Venues]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Venues] ON
INSERT [dbo].[Venues] ([Id], [Description], [Name], [Address_Id]) VALUES (1, N'Venue1', N'Venue1', 4)
INSERT [dbo].[Venues] ([Id], [Description], [Name], [Address_Id]) VALUES (3, N'Desc2', N'Venue2', 8)
SET IDENTITY_INSERT [dbo].[Venues] OFF
/****** Object:  Table [dbo].[AllUsers]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[AllUsers] ON
INSERT [dbo].[AllUsers] ([Id], [UserName], [Password], [Email], [Phone], [Status], [__Disc__], [Address_Id], [Role_Id]) VALUES (3, N'Vishal', N'Anil', N'vishalanil@gmail.com', N'123456', 1, N'Organizer', 1, 1)
INSERT [dbo].[AllUsers] ([Id], [UserName], [Password], [Email], [Phone], [Status], [__Disc__], [Address_Id], [Role_Id]) VALUES (4, N'Agent1UserName', N'Agent1Password', N'agent1@tgi.com', N'123123', 1, N'Agent', 2, 3)
INSERT [dbo].[AllUsers] ([Id], [UserName], [Password], [Email], [Phone], [Status], [__Disc__], [Address_Id], [Role_Id]) VALUES (5, N'new-1', N'Organizer1Password', N'organizer1@tgi.com', N'123321', 1, N'Organizer', 5, 2)
INSERT [dbo].[AllUsers] ([Id], [UserName], [Password], [Email], [Phone], [Status], [__Disc__], [Address_Id], [Role_Id]) VALUES (6, N'Customer1-UserName', N'Customer1-Password', N'customer1@tgi.com', N'321321', 1, N'Customer', 6, 4)
SET IDENTITY_INSERT [dbo].[AllUsers] OFF
/****** Object:  Table [dbo].[AgentBranches]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[AgentBranches] ON
INSERT [dbo].[AgentBranches] ([Id], [Address_Id], [User_Id]) VALUES (1, 3, 4)
SET IDENTITY_INSERT [dbo].[AgentBranches] OFF
/****** Object:  Table [dbo].[EventAgent]    Script Date: 08/29/2011 18:25:10 ******/
INSERT [dbo].[EventAgent] ([EventAgent_Agent_Id], [Agents_Id]) VALUES (2, 4)
INSERT [dbo].[EventAgent] ([EventAgent_Agent_Id], [Agents_Id]) VALUES (3, 4)
/****** Object:  Table [dbo].[Payments]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Payments] ON
INSERT [dbo].[Payments] ([Id], [Amount], [SuccessfulPayment], [PaymentMode_Id], [User_Id]) VALUES (4, N'1000', 1, 1, 6)
SET IDENTITY_INSERT [dbo].[Payments] OFF
/****** Object:  Table [dbo].[EventVenues]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[EventVenues] ON
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id]) VALUES (1, 2, 3)
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id]) VALUES (2, 2, 1)
INSERT [dbo].[EventVenues] ([Id], [Event_Id], [Venue_Id]) VALUES (4, 2, 1)
SET IDENTITY_INSERT [dbo].[EventVenues] OFF
/****** Object:  Table [dbo].[UserEvent]    Script Date: 08/29/2011 18:25:10 ******/
/****** Object:  Table [dbo].[TicketTypes]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[TicketTypes] ON
INSERT [dbo].[TicketTypes] ([Id], [Type], [Price], [TotalQuantity], [Description], [EventDate], [Status], [CustomTemplate], [TicketTemplate_Id], [EventVenue_Id]) VALUES (3, N'Ticket Type -1', CAST(100 AS Decimal(18, 0)), 100, N'Ticket Type - 1', CAST(0x00009F5C00000000 AS DateTime), N'1', N'Cutom Template', 7, 1)
INSERT [dbo].[TicketTypes] ([Id], [Type], [Price], [TotalQuantity], [Description], [EventDate], [Status], [CustomTemplate], [TicketTemplate_Id], [EventVenue_Id]) VALUES (5, N'Ticket Type -2', CAST(575 AS Decimal(18, 0)), 500, N'Ticket Type - 2', CAST(0x00009F5D00000000 AS DateTime), N'1', N'Custom Template 2', 7, 2)
INSERT [dbo].[TicketTypes] ([Id], [Type], [Price], [TotalQuantity], [Description], [EventDate], [Status], [CustomTemplate], [TicketTemplate_Id], [EventVenue_Id]) VALUES (6, N'3', CAST(3 AS Decimal(18, 0)), 3, N'3', CAST(0x0000A13900000000 AS DateTime), N'1', NULL, 1, 4)
SET IDENTITY_INSERT [dbo].[TicketTypes] OFF
/****** Object:  Table [dbo].[Contacts]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Contacts] ON
INSERT [dbo].[Contacts] ([Id], [Phone], [Email], [Name], [TicketTypeContact_Contact_Id], [Address_Id]) VALUES (1, N'123456', N'contact1@tgi.com', N'Contact1', NULL, NULL)
SET IDENTITY_INSERT [dbo].[Contacts] OFF
/****** Object:  Table [dbo].[TicketQuotas]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[TicketQuotas] ON
INSERT [dbo].[TicketQuotas] ([Id], [QuotaQuantity], [TicketType_Id], [AgentBranch_Id]) VALUES (2, 60, 3, 1)
SET IDENTITY_INSERT [dbo].[TicketQuotas] OFF
/****** Object:  Table [dbo].[Tickets]    Script Date: 08/29/2011 18:25:10 ******/
SET IDENTITY_INSERT [dbo].[Tickets] ON
INSERT [dbo].[Tickets] ([Id], [PhysicalTicketNumber], [EventDate], [ElectornicTicketNumber], [Barcode], [TicketQuota_Id], [Payment_Id], [User_Id]) VALUES (3, N'1', CAST(0x00009F5C00000000 AS DateTime), N'7ef652a5-2cc3-4633-a722-2589cfc72344', N'1', 2, 4, 6)
SET IDENTITY_INSERT [dbo].[Tickets] OFF
